#!/bin/bash
# 全量覆盖

tab_arr=(ads_aml_alert_efficiency ads_aml_customer_risk_profile ads_aml_daily_risk_report ads_aml_regulatory_monthly)

for i in ${tab_arr[@]}; do
    sqoop export \
    --connect jdbc:mysql://192.168.88.148:3306/ADS \
    --username root \
    --password 123456 \
    --table $i \
    --hcatalog-database ads \
    --hcatalog-table $i \
    -m 1
done

